The following example searches for a
SqlShimParameter with a given
ParameterName within a
SqlShimParameterCollection<T>. If the parameter exists, the example displays the name and index of the parameter. If the parameter does not exist, the example displays an error. This example assumes that a
SqlShimParameterCollection<T> has already been created.
public void SearchDynamicsParams() {
// ...
// create DynamicsParameterCollection myParameters
// ...
if (!myParameters.Contains("DName"))
MessageBox.Show("ERROR: no such parameter in the collection");
else
MessageBox.Show("Name: " + myParameters["DName"].ToString() +
"Index: " + myParameters.IndexOf("DName").ToString());
}
Public Sub SearchDynamicsParams()
' ...
' create DynamicsParameterCollection myParameters
' ...
If Not myParameters.Contains("DName") Then
MessageBox.Show("ERROR: no such parameter in the collection")
Else
MessageBox.Show("Name: " & myParameters("DName").ToString() & _
"Index: " & myParameters.IndexOf("DName").ToString())
End If
End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2